#! /bin/bash
export LANG=en_US.UTF-8

#WARNLIMIT=-1 		#警告值 超过该值则认为是需要告警
#ERRORLIMIT=-1 		#错误值 超过该值认为是错误

CURNUM=				#当前的性能参数

WranResultStr=		#最后形成的告警字符串
ErrorResultStr=		#最后形成的错误字符串
DataResultStr=		#性能呢个参数字符串
MYSQL_SLOW_LOG_PATH=
MYSQLHOME="/usr/bin"
MYSQLHOST=127.0.0.1
USER=root
PASSWORD=
PORT=

#连接数
CONN=-1
CONNMIN=-1
CONNMAX=-1
#CPU
CPU=-1
CPUMIN=-1
CPUMAX=-1
#内存
MEMORY=-1
MEMORYMIN=-1
MEMORYMAX=-1

#慢查询数目
Slow_queries=-1
Slow_queries_min=-1
Slow_queries_max=-1

FLAGE=
FLAGEID=
#是否输出FLAGPID
FLAGEOPID=1
#是否输出RUNTIME
RUNTIME=1
#是否输出STARTTIME
STARTTIME=0
QUOTASTR=
quota=

SlowResult=

function gotErr(){
	if [ "$1" -eq 0 ];then
		echo "mailstatedes=各项指标恢复正常,且没有慢查询 statedes=各项指标恢复正常,且没有慢查询|$DataResultStr${SlowResult}"
	elif [ "$1" -eq 1 ];then 
		echo "quota=${quota} mailstatedes=$WranResultStr statedes=$WranResultStr ${QUOTASTR} |$DataResultStr${SlowResult}"
	elif [ "$1" -eq 2 ];then 
		if [[ "${WranResultStr}" != "" ]]; then
			echo "quota=${quota} mailstatedes=${WranResultStr},${ErrorResultStr} statedes=${WranResultStr},${ErrorResultStr} ${QUOTASTR}|$DataResultStr${SlowResult}"
			else
			echo "quota=${quota} mailstatedes=${ErrorResultStr} statedes=${ErrorResultStr} ${QUOTASTR}|$DataResultStr${SlowResult}"
		fi
		
	elif [ "$1" -eq 3 ];then 
		echo "mailstatedes=无法获取到指标,疑似组件故障,请确认并请检查监控脚本和运维平台配置 statedes=无法获取到指标,疑似组件故障,请确认并请检查监控脚本和运维平台配置|$DataResultStr"
	fi

	exit $1
}

function isAlive(){
    FLAGEID=$(netstat -lnp | grep $PORT | grep mysqld | awk '{print $NF}' | awk -F '/' '{print $1}')
	isAliveStr=$(ps aux |grep mysql | grep -v grep| grep -v check_mysql |grep "$FLAGEID" |wc -l)
	if [[ "$isAliveStr" -eq 0 ]];then
		gotErr 3
	fi
	if [[ "$isAliveStr" -gt 1 ]];then
		echo "你的端口需要唯一标识一个进程"
		showHelp
	fi
}


#处理连接数
function getConnNum(){
	CURNUM=$( netstat -apn | grep $FLAGEID | grep ESTABLISHED | wc -l)
}

#ps aux 4是内存 累加4的值
function getMemory(){
	CURNUM=$(ps aux | grep $FLAGEID |awk 'BEGIN{sum=0}{sum+=$4}END{print sum}')
}

#ps aux 3是CPU 累加3的值
function getCPU(){
	CURNUM=$(ps aux | grep $FLAGEID |awk 'BEGIN{sum=0}{sum+=$3}END{print sum}')
}

#ps -eo pid,etime 是查询进程运行时间
function getRuntime(){
	CURNUM=$(ps -eo pid,etime | grep $FLAGEID |awk '{if($1=='$FLAGEID') print $2}')
}

#ps -eo pid,lstart是查询进程的开始时间
function getStarttime(){
	CURNUM=$(ps -eo pid,lstart | grep $FLAGEID |awk '{if($1=='$FLAGEID') print $2 ,$3 ,$4 ,$5 ,$6}')
}
#依据传入的参数值来判断我们要监控的服务是什么
#然后通过各个函数获取到具体的值
#值之间的
function analysisStat(){

	if [ "$CONN" -eq 1 ];then
		getConnNum
		parseFileds "CONN" $CONNMIN $CONNMAX
	fi
	if [ "$CPU" -eq 1 ];then
		getCPU
		parseFileds "CPU" $CPUMIN $CPUMAX
	fi
	if [ "$MEMORY" -eq 1 ];then
		getMemory
		parseFileds "MEMORY" $MEMORYMIN $MEMORYMAX
	fi
	
	if [ "$FLAGEOPID" -eq 1 ];then
			CURNUM=$FLAGEID
			parseFileds "FLAGEPID" $CURNUM $CURNUM
	fi
	if [ "$RUNTIME" -eq 1 ];then
			getRuntime
			parseTimeFileds "RUNTIME" $RUNTIME $RUNTIME		
	fi
	if [ "$STARTTIME" -eq 1 ];then
			getStarttime
			parseTimeFileds "STARTTIME" $STARTTIME $STARTTIME		
	fi
	if [ "$Slow_queries" -eq 1 ];then
	  slow_query_script="$(cd `dirname $0`;pwd)/check_slow_query.py"
    SlowResult=`$slow_query_script -f $MYSQLHOME -w $Slow_queries_min -c $Slow_queries_max -l $MYSQL_SLOW_LOG_PATH`
		#SlowResult=$(./cmd/linux/check_slow_query.py -f $MYSQL_SLOW_LOG_PATH -w $Slow_queries_min -c $Slow_queries_max)
		EXITCODE=$?
		if [[ "$EXITCODE" -eq 3 ]];then
			CURNUM=3
			WranResultStr="${WranResultStr}无法取到慢查询的值,${SlowResult}"
			if [[ ${quota} != "" ]]; then
        	    quota="${quota},"
      fi
      quota="${quota}慢查询"
      QUOTASTR="${QUOTASTR}慢查询=无法取到慢查询的值,${SlowResult} "
      SlowResult=""
		else
			COUNT=$(echo $SlowResult| awk -F '<<COUNT>>' '{print $1}')
			SlowResult=$(echo $SlowResult| awk -F '<<COUNT>>' '{print $2}')
			CURNUM=${COUNT}
      if [[ "$CURNUM" == "" ]];then
              CURNUM=0
      fi
			parseFileds "慢查询" $Slow_queries_min $Slow_queries_max
		fi
	fi

}
function parseTimeFileds(){
	val1=$(echo "$CURNUM $2")
	val2=$(echo "$CURNUM $3")
  DataResultStr="$DataResultStr $1=$CURNUM;$2;$3;0;0"
}
#CURNUM			当前值
#WARNLIMIT 		告警的上限
#ERRORLIMIT 	异常的上限
#判断以上三个值并拼接结果字符串
function parseFileds(){
	val1=$(echo "$CURNUM $2"| awk '{if($1<=$2){print 1}else{print 0}}')
	val2=$(echo "$CURNUM $3"| awk '{if($1<=$2){print 1}else{print 0}}')

	DataResultStr="$DataResultStr $1=$CURNUM;$2;$3;0;0"
	if [ $val1 -eq 1 ];then
		return 0
	elif [[ $val1 -eq 0 && $val2 -eq 1 ]];then
		if [[ ${WranResultStr} != "" ]]; then
			WranResultStr="${WranResultStr},"
		fi

		WranResultStr="${WranResultStr}$1当前值为${CURNUM}超过告警值${2}"

		if [[ ${quota} != "" ]]; then
			quota="${quota},"
		fi

		quota="${quota}$1"

		QUOTASTR="${QUOTASTR}$1=$1当前值为${CURNUM}超过告警值${2} "

		return 1
	else
		if [[ ${ErrorResultStr} != "" ]]; then
			ErrorResultStr="${ErrorResultStr},"
		fi
		ErrorResultStr="${ErrorResultStr}$1当前值为${CURNUM}超过紧急值${3}"

		if [[ ${quota} != "" ]]; then
			quota="${quota},"
		fi

		quota="${quota}$1"

		QUOTASTR="${QUOTASTR}$1=$1当前值为${CURNUM}超过紧急值${3} "
		
		return 2
	fi
}

#分析结果 给出给出状态
function analysisResult(){
	if [[ "$WranResultStr" == "" && "$ErrorResultStr" == "" ]];then
		gotErr 0
	elif [[ "$ErrorResultStr" == "" ]];then
		gotErr 1
	else
		gotErr 2
	fi
}

#输出错误信息并且退出程序
function showHelp(){
	if [ "$1" != "" ];then
		echo "请输入$1"
	fi
	echo "check_mysql.sh 可以监听本地的mysql的状态 参数如下"
	echo "check_mysql.sh [-w 连接数,CPU,内存,慢查询数目] [-c 连接数,CPU,内存,慢查询数目] [ -b <str>] [ -p <port>] [ -l <slow_query_path>]"
	echo "-b 表示安装目录 默认为/usr/bin"
	echo "-p 表示MySQL服务器的端口 默认为3306"
	echo "-l 表示MySQL慢查询日志路径"
	exit 1
}

#检查参数是不是数字
function isNumber(){
	isNum=$(echo "$1" | awk '{print($0~/^([0-9])+[\.]?([0-9])?$/)?1:0}')
	return $isNum
}

function isLarge(){

	isNumber $1
	if [[ $? -eq 0 ]]; then
		return 1
	fi

	isNumber $2
	if [[ $? -eq 0 ]]; then
		return 1
	fi

	isLarge=$(echo "$1 $2"| awk '{if($1>=$2){print 1}else{print 0}}')
	if [ $isLarge -eq 1 ];then
		return 0
	else
		return 1
	fi
}

function checkARG(){
	if [[ "$2" != "" && "$3" != "" ]];then
		isLarge "$3" "$2"
		if [[ $? -eq 1 ]]; then
			return 1
		else
			$1=1
		fi
	fi
	return 0
}

#检查参数是否合法
#即参数是否是小数和整数
#对于守护进程的选择 这个值可以不验证
function checkALL(){
	if [[ "$CONNMIN" != "" || "$CONNMAX" != "" ]];then
		if [[ "$CONNMAX" == "" || "$CONNMIN" == "" ]]; then
			return 1
		fi

		isLarge "$CONNMAX" "$CONNMIN"
		if [[ $? -eq 1 ]]; then
			return 1
		else
			CONN=1
		fi
	fi
	if [[ "$CPUMIN" != "" || "$CPUMAX" != "" ]];then
		if [[ "$CPUMAX" == "" || "$CPUMIN" == "" ]]; then
			return 1
		fi

		isLarge "$CPUMAX" "$CPUMIN"
		if [[ $? -eq 1 ]]; then
			return 1
		else
			CPU=1
		fi
	fi
	if [[ "$MEMORYMIN" != "" || "$MEMORYMAX" != "" ]];then

		if [[ "$MEMORYMAX" == "" || "$MEMORYMIN" == "" ]]; then
			return 1
		fi

		isLarge "$MEMORYMAX" "$MEMORYMIN"
		if [[ $? -eq 1 ]]; then
			return 1
		else
			MEMORY=1
		fi
	fi

	if [[ "$Slow_queries_min" != "" || "$Slow_queries_max" != "" ]];then

		if [[ "$Slow_queries_max" == "" || "$Slow_queries_min" == "" ]]; then
			return 1
		fi

		isLarge "$Slow_queries_max" "$Slow_queries_min"
		if [[ $? -eq 1 ]]; then
			return 1
		else
			Slow_queries=1
		fi
	fi
	return 0
}

function parseARG(){
	#it mean warning
	if [ $1 -eq 1 ];then
 		CONNMIN=$(echo $2 | awk -F ',' '{print $1}' | sed "s/[^0-9]//g")
 		CPUMIN=$(echo $2 | awk -F ',' '{print $2}' | sed "s/[^0-9]//g")
 		MEMORYMIN=$(echo $2 | awk -F ',' '{print $3}' | sed "s/[^0-9]//g")
		Slow_queries_min=$(echo $2 | awk -F ',' '{print $4}' | sed "s/[^0-9]//g")
 	else
 		CONNMAX=$(echo $2 | awk -F ',' '{print $1}' | sed "s/[^0-9]//g")
 		CPUMAX=$(echo $2 | awk -F ',' '{print $2}' | sed "s/[^0-9]//g")
 		MEMORYMAX=$(echo $2 | awk -F ',' '{print $3}' | sed "s/[^0-9]//g")
		Slow_queries_max=$(echo $2 | awk -F ',' '{print $4}' | sed "s/[^0-9]//g")
 	fi

}

while getopts "w:c:u:p:b:l:hP:" arg
do
	case $arg in
		w)
			parseARG 1 "$OPTARG"
			;;
		c)
			parseARG 2 "$OPTARG"
			;;
		h)
			showHelp
			;;
		u)
		 	USER=$OPTARG
			;;
		p)
		    PORT=$OPTARG
			;;
		b)
			MYSQLHOME=$OPTARG
			;;
		P)
			PASSWORD=$OPTARG
			;;
		l)
			MYSQL_SLOW_LOG_PATH=$OPTARG
			;;			
		?) 
			showHelp
			;;
	esac
done

if [[ "$PORT" == "" ]];then
	showHelp "特征项"
fi

checkALL
if [[ $? == 1 ]];then
	showHelp "正确参数"
fi


#插件正题部分 
#确定存活的
#启动
#分析

isAlive
analysisStat
analysisResult
